So you got one more topic that I want to get in the here that deals with validation and this isn't so
much validating input of records into a list.
But we're going to make more dynamic or a more dynamic interface to work with formulas.
So I travel back in time here.
I've gone back to the list functions worksheet that we worked with in the previous sections when we
were talking about list functions.
And I still got all the work you created earlier.
Now what I'd like to do is modify my different categories here.
What is cells.
Each for each seven and each 10.
I want to create dropdown menus so somebody could jump in here and just through a couple clicks of the
mouse change the category from software to one of our other categories and update the calculation.
Now I'm going to use the same technique that we just got done talking about utilizing validation lists
to create these three separate drop downs but I'm going to throw in a little bit of a difference in
here's something that we did not see in the previous lectures and this is this deals with how you create
your list.
So what I'm going to do here is scroll off to the right just some place empty maybe and in column.
And I'm going to create a list of the valid categories so I will say we got software and we got copying
We got rents and I'm forgetting what else we got over there and see if we got overhead supplies overhead
supplies and so on we've got we have a few more over there we got miscellaneous advertising technical
support.
I'm going to put one more I would say we got technical support now and I'm going to stop right there
.
Ideally we'd meet we'd make the entire list we hear of each of these unique values.
But by just limiting it right here where we're going to get the point.
What's happening.
So this lists I'm going to use to create the drop downs that the users can pick from for the different
categories.
All right.
Now that I've got the list of valid options I'm now going to select these three cells that H for H 7
and H 10 and I just held down my control key and clicked on all three of them.
So now with that selected I'll go up to my data tab.
I'm going to go back to data validation data validation.
I'm going to do settings.
And once again I'm not going to allow any value but I didn't tell him that to pick from a list.
And my source rather than this time then typing it in I'm going to go select my list over here.
What is that in 3 to an 8.
And that's it.
Oh OK.
And I've now got little drop downs so I go from software to copy and I've updated my formula through
a nice day dynamic dropdown list so I'm trying to create something that's more user friendly intuitive
right just through a little dropdown.
We've now got these a namak calculations or dynamic input in interaction with these calculations.
Now what if I add another value over here like I jump over to in 7 or 6 and I press control plus my
keyboard Right-Click inserts let's just insert one here.
You know I mean I have to write quick All right quick.
I'll insert a row and I insert something else here let's say we get contractors one that I didn't have
before.
All right contractors there it is.
I hopped back over to my drop downs and look at that.
I've now got contractors.
So there's dynamic little interface that users can now get into to build to update these dynamic calculations
and all I'm using is a validation lists.
Try this out.
Opening up the exercise file.
Jump back to disfunctions.
If you didn't create the calculations earlier because he didn't go through the previous section Make
sure you do that or create some calculations that you can then feed in of value from a validated list
.